Integrity Constraints in Spatial Databases
نویسندگان
چکیده
A number of integrity constraints must be observed when updating a database, in order to preserve the semantics and the quality of stored data (Elmasri & Navathe, 2000). Achieving and preserving the integrity of data is an established field in the database area. However, within the scope of geographic applications, special problems come up due to the locational aspects of data (Plumber & Groger, 1997). Most geographical information systems (GIS) use data that depend on topological relationships, and sometimes these data must be explicitly represented in the database, requiring special attention for the maintenance of the semantic integrity. Enforcing the integrity constraints must be considered one of the main implementation goals (Borges et al., 1999). Thus, it is convenient to explicitly specify on the geographic application schema the situations where the constraints cannot be disregarded. Many mistakes in the data entry process could be avoided, if digitizing processes based on these constraints were implemented.
منابع مشابه
From Transactional Spatial Databases Integrity Constraints to Spatial Datacubes Integrity Constraints
Spatial multidimensional databases (also called "spatial datacubes") are the cornerstone of the emerging Spatial On-Line Analytical Processing technology (SOLAP). They are aimed at supporting Geographic Knowledge Discovery (GKD) as well as certain types of spatial decision-making. Although these technologies seem promising at first glance, they may provide unreliable results if one does not con...
متن کاملTowards Specialized Integrity Constraints for Spatial Datacubes
Spatial datacubes (also called "spatial multidimensional databases") are the cornerstone of the emerging Spatial On-Line Analytical Processing (SOLAP) technology. They are aimed at supporting Geographic Knowledge Discovery (GKD) as well as certain types of spatial decision-making. Although these technologies seem promising at first glance, they may provide unreliable results if one does not con...
متن کاملFormal classification of integrity constraints in spatiotemporal database applications
Imposing integrity constraints is an efficient way to improve data quality in databases. Effective imposition of integrity constraints requires their precise distinction and specification. Despite a few efforts for enhancing the distinction and specification of the integrity constraints in spatial and spatiotemporal databases by their classifications, these classifications fail to precisely dis...
متن کاملDeriving Spatial Integrity Constraints from Geographic Application Schemas
Integrity constraints of various kinds must be observed when creating or updating a database in order to preserve the semantics and the quality of stored data (Elmasri & Navathe, 2000). Within the scope of geographic applications, integrity assurance requires special attention from the designer, since most geographic applications use data that depend on spatial relationships (Egenhofer & Franzo...
متن کاملTowards the Reduction of Spatial Joins for Knowledge Discovery in Geographic Databases Using Geo-Ontologies and Spatial Integrity Constraints
Spatial join is the most expensive operation in geographic databases, but essentially important to compute spatial relationships intrinsic to geographic data. In account of spatial relationships real world entities may affect the behavior of other entities in the neighborhood. Spatial relationships are fundamental for knowledge discovery in geographic databases and are strongly related to the d...
متن کاملThe Use of a Metadata Repository in Spatial Database Development
Database schemas currently used to define spatial databases are deficient in that they do not incorporate facilities to specify business rules/integrity constraints. This shortcoming has been noted by Gnther and Lamberts [Gnther & Lamberts, 1994] who commented that geographical information systems (GIS) do not generally offer any functionality to preserve semantic integrity. It is desirable t...
متن کامل